SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_ChiTietTour_ThongTinTour]
	@MaTour CHAR(20)
AS
Begin
	SELECT	TEN_TOUR, MA_TOUR, NGAY_DI, DD_TAPTRUNG, NOI_KH, SO_CHO_CON_NHAN
	FROM	TOUR
	WHERE	MA_TOUR = @MaTour
END

GO
